<?php
$db = sqlite_open("database.sqlite");
sqlite_query($db,"CREATE TABLE pages (
  id int,
  title varchar,
  tags varchar
)");
sqlite_query($db,"CREATE TABLE revisions (
  pageid int,
  time int,
  body varchar
)");
sqlite_query($db,"INSERT INTO pages (
  id,
  title,
  tags
) VALUES (
  0,
  'main'
  'test'
)");
sqlite_query($db,"INSERT INTO revisions (
  pageid,
  time,
  body
) VALUES (
  0,
  ".time().",
  'this is a test page.'
)");
echo "done";
?>